This was a fun project, created a few years ago now. Experimented rendering with cycles, then adding in smoke from Blender Internal. Check out the Tutorial Series here: https://www.youtube.com/watch?v=dfnMwHC-qj0
Breathtaking Waterfalls In Blender